Installing SequeLink® Server on z/OS UNIX System Services

SequeLink Server for JDBC Socket is supported on z/OS UNIX System Services (USS).

NOTE: See "Installing SequeLink® Server on a Windows Server Platform" and "Installing SequeLink® Server on Linux and UNIX" to install SequeLink Server for JDBC Socket on Windows and UNIX.

User Login for Installation

To install SequeLink Server for JDBC Socket on z/OS USS, you must log on to the z/OS machine with root authority, also known as superuser authority, which means you should have UID(0) defined in your OMVS segment.

Security Authorities for Installation

Two levels of UNIX Security on z/OS USS exist, the normal UNIX-level and the z/OS UNIX-level. The z/OS UNIX-level security, which is recommended, is triggered when the profile BPX.DAEMON or BPX.SERVER in the FACILITY class is defined. This level forces program fetch control. If z/OS UNIX-level security is active, you need READ authority on profile BPX.FILEATTR.PROGCTL to install SequeLink Server for JDBC Socket.

Installation Procedure

To install the SequeLink Server for JDBC Socket on z/OS USS, you must:

Transferring the tar file

  1. Mount the SequeLink DVD on a machine that has file transfer software. See "Mounting Your DVD" for DVD mounting instructions.
  2. Log on to the z/OS USS machine with root authority. Use either a Telnet or TSO OMVS session to start a shell. Telnet is the preferred interface to use.
  3. Create a SequeLink home directory on the z/OS USS machine if one does not exist. For example, to create a SequeLink home directory named sqlnk in the usr directory, enter:

    4. mkdir /usr/sqlnk

  4. On the machine that has the DVD mounted, change to the directory on the SequeLink DVD for your server platform. Transfer the slsoc2jdbc.tar file in binary format to the SequeLink home directory that you created in Step 3. If you transfer the file in the wrong format, the SequeLink Server installation will fail.

Extracting the contents of the tar file

On the z/OS USS machine, access the tar file you transferred and extract the contents by entering: 

tar -xvof slsoc2jdbc.tar

Running the installation script

When you run the installation script, you will be prompted for choices you need to make and information you need to enter. Default answers to questions are enclosed in square brackets, [ ]. To accept the default value, press ENTER.

NOTE: Run the installation script on the z/OS USS machine.

To run the installation script:

  1. Make sure you are logged on to the z/OS USS machine with root authority.
  2. Change to the SequeLink home directory. For example, enter:

    3. dvd /usr/sqlnk

  3. Start the installation script by entering:

    4. sh install.sh

  4. At the prompt, select the SequeLink Server you want to install. After you enter your choice, the SequeLink Server installer file is uncompressed.

    5. DataDirect SequeLink Server installer is uncompressing now. Please wait...

  5. Verify the SequeLink Server to install.

    6. -------------------------------------------------------

    You are installing the product:

    SequeLink Server for JDBC Socket

    Version 6.0 on z/OS Unix System Services

    -------------------------------------------------------

    Do you want to continue (Y/N)? [Y]

    Enter Y to continue the installation. Enter N to stop the installation; no software will be installed.

  6. Enter the installation directory, or press ENTER to accept the default installation directory, which is /usr/slserver60. If the directory does not exist, it is created for you.

    7. -------------------------------------------------------

    Enter the target directory where you want to install SequeLink Server.

    If this directory does not exist, it will be created for you.

    -------------------------------------------------------

    Enter target directory ? [/usr/slserver60] :

  7. Enter the Java Runtime Environment directory; this directory must contain 'bin/classic/libjvm.so'. For example, /usr/lpp/java/IBM/J1.4.

    8. Enter the full path of the directory where the Java Runtime Environment (JRE) is installed.

  8. The installation script prompts you for information that is required to create the SequeLink Agent that allows the SequeLink administrator to configure, manage, and monitor this SequeLink Server using the SequeLink Manager. To create a SequeLink Agent, enter the user ID of the SequeLink administrator account, or press ENTER to accept the default. Typically, you would enter your own user ID as SequeLink administrator. Make sure that the user ID that you enter is defined in RACF.

    9. Please enter the Unix account name which will be allowed to remotely administer this SequeLink Server [authenticated] :

  9. Enter the name of the SequeLink Agent, or press ENTER to accept the default.

    10. Enter the name of this SequeLink agent service [SLAgent]:

  10. Enter the TCP/IP port on which the SequeLink Agent will be listening, or press Enter to accept the default, which is 19995. The port you enter must be a unique port.

    11. Enter the TCP/IP port for your SequeLink agent service [19995]:

    NOTE: If the port you specify is not unique, the installation will fail and no software will be installed.

  11. Enter the name of the SequeLink Server for JDBC Socket service, or press ENTER to accept the default, which is SLSocket2JDBC.

    12. Enter the name of your SequeLink for JDBC Socket service or press ENTER to accept the default [SLSocket2JDBC]:

  12. Enter the TCP/IP port on which the SequeLink Server for JDBC Socket will be listening for connection requests, or press Enter to accept the initial default, which is 19996. The port you enter must be a unique port.

    13. Enter the TCP/IP port for your SequeLink for JDBC Socket service [19996]:

    NOTE: If the port you specify is not unique, the installation will fail and no software will be installed.

  13. Enter the pathname where the JDBC drivers are installed, for example: /u/drivers/JDBC/cac30/cacjdb21.jar. If you specify more than one JDBC driver pathname, you must separate the values with a colon (:).

    14. Enter the CLASSPATH for the back-end JDBC drivers you want to use with this SequeLink Server for JDBC Socket:

  14. Enter the JDBC driver class name, for example:
    com.ddtek.jdbc.crossaccess30.CrossAccessDriver. Refer to your JDBC driver documentation for the driver's class name or to the output of the ivcheckjdbcdriver utility.

    15. Enter the JDBC driver classname for the default server datasource:

    See "Checking Your Third-Party JDBC Driver for SequeLink® Server for JDBC Socket" for information about using the ivcheckjdbcdriver utility.

  15. Enter the JDBC driver connection URL, for example:
    jdbc:sequelink://10.30.14.109.14902
    or
    jdbc:dd-crossaccess30:EXIMS:tcp/10.30.14.109/9001:CODEPAGE=USS

    16. Refer to your JDBC driver documentation or to the output of the ivcheckjdbcdriver utility to determine the connection URL. See "Checking Your Third-Party JDBC Driver for SequeLink® Server for JDBC Socket" for information about using the ivcheckjdbcdriver utility.

  16. Enter the name for the database properties file, or press ENTER to accept the default. Properties files are used to provide settings needed for the SequeLink Clients that cannot be supplied by the back-end JDBC driver. These files are supplied in your installation package in the bin/odbc2jdbc/classes/com/ddtek/jniutil directory. The names of the properties files that are shipped with the product are: crossaccess30, db2v7mvs, db2v8udb, derby, oracle91, sqlsrv2000, sybase125.

    17. When you enter a name, specify the file name without the .properties extension, for example, crossaccess30. If you do not find the appropriate properties file for your JDBC driver, contact DataDirect Technologies technical support.

    Enter the name of the DataDirect supplied database properties file for the default server datasource or press Enter to use the default settings.

  17. Review the installation settings that you have specified. Then, you can either:
    • Press ENTER to accept these settings and start the installation.
    • Change any of the settings.
    • End the installation.
---------------------------------------------------------------------- 
Ready to start installation with the following settings: 
SequeLink home directory : /u/qa/sl60/server 
SequeLink Agent settings : Administrator : mfigp 
                           Service name : SLAgent 
                           TCP/IP port : 15999 
SequeLink Socket2JDBC settings : Service name : SLSocket2JDBC 
                                TCP/IP port : 15936 
JRE installation directory : /usr/lpp/java14/J1.4 
JDBC Driver CLASSPATH    : 
/sqlnkdev/releases/ext/JDBCDriversForSocket/07/Drivers.jar 
JDBC Driver ClassName    : com.ddtek.jdbc.crossaccess30.CrossAccessDriver 
JDBC Connection URL      : 
jdbc:dd-crossaccess30:EXIMS:tcp/10.30.14.109/9001:CODEPAGE=USS 
Database properties file : crossaccess30 
Link service executables : No 
You will need approx. 24000 kBytes free diskspace in your SequeLink 
home directory (depending on your platform and configuration.). 
---------------------------------------------------------------------- 
1) Start installation with these settings 
2) Change SequeLink home directory 
3) Change SequeLink Agent settings 
4) Change SequeLink Socket2JDBC settings 
5) Change JRE installation directory 
6) Change JDBC Driver related setting 
9) Abort installation 
Enter your choice [1] ?
  1. During the installation, both the SequeLink Server for JDBC Socket and the SequeLink Agent are installed. When the installation of the SequeLink Agent is complete, the installer prompts you to start the SequeLink Agent service. Press ENTER to start the service. Enter N if you do not want to start the SequeLink Agent service at this time. The service can be started at a later time.

    2. Would you like the installer to start the SequeLink Agent (Y/N)? [Y]

  2. The installer now prompts you to start the SequeLink Service for JDBC Socket. Press ENTER to start the SequeLink Service for JDBC Socket. Enter N if you do not want to at this time. The service can be started at a later time.

    3. Would you like to start the SequeLink Server for Socket2JDBC (Y/N)? [Y]

  3. You may need to tune the SequeLink Server for JDBC Socket depending on your workload. For information about tuning, refer to the SequeLink Administrator's Guide.

Environment Variables

Table 2-18 lists the environment variables set for the SequeLink Server for JDBC Socket during installation, and provides a description of what is set in the variables.

Table 2-18. Environment Variables Set During Installation
Environment Variable
Description
<LIBPATH>
Shared library path for the ODBC-to-JDBC bridge and the Java Virtual Machine
CLASSPATH
Classpath containing all JDBC drivers that need to be accessed by the SequeLink Server for JDBC Socket and the classes for the SequeLink for JDBC Socket service
ISLVINI
Directory for the license ini file (does not apply on z/OS UNIX System Services)
ODBCINI
File with the ODBC configuration information for the ODBC-to-JDBC bridge
SL_JAVA_OPTIONS
Options to influence the Java Virtual Machine used by the backend JDBC driver
For example: 
SL_JAVA_OPTIONS=Xms32m-Xmx64m-Xcomp-verbose